package cn.dmrliu.edu.publish.mapper;

import cn.dmrliu.edu.publish.bean.TrafficKeywords;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TrafficKeywordsMapper {
    @Select("select\n" +
            "  keyword,\n" +
            "  sum(keyword_count) score\n" +
            "from dws_traffic_keyword_page_view_window\n" +
            "where toYYYYMMDD(stt) = #{date}\n" +
            "group by keyword;")
    List<TrafficKeywords> selectKeyword(Integer date);
}
